www.gusucode.com > 茶都拼客网全功能版 8 > 茶都拼客网全功能版 8.8源码程序/teasdxmccom/茶都拼客网V8.8(全功能,无限制,完全开源)/Ku_type/Index_PTShangjia.asp
<% set rsmai=server.CreateObject("adodb.recordset") sqlmai="select top 5 * from [shangjia] where shenhe=1 and xinyu=0 order by addtime desc" rsmai.open sqlmai,conn,1,1 %> <div align="center"> <table border="0" width="137" height="121" cellpadding="0" cellspacing="0"> <%if Rsmai.eof or Rsmai.bof then%> <tr> <td height="121" width="137"> <p align="center">暂无推荐的普通商家</td> </tr> <% else %> <tr> <%do while not rsmai.eof%> <td height="141" width="137"> <div align="center"> <table border="0" width="145" height="139" cellpadding="0" cellspacing="1" > <tr> <td height="107" width="135" style="border: 1px solid #D0D4D9" align="center"> <a href="My_shop.asp?guxing=<%=rsmai("id")%>"> <img border="0" src="<%if rsmai("logo")<>"" then%><%=rsmai("logo")%><%else%>ku_Img/nopic120-90.gif<%end if%>" width="126" height="99" alt="店铺名称:<%=rsmai("name")%>
创建时间:<%=rsmai("addtime")%>
联系人:<%=rsmai("username")%>"></a></td> <td height="107" width="5"> </td> </tr> <tr> <td height="29" width="137" align=center><b>商家</b>:<a href="My_shop.asp?guxing=<%=rsmai("id")%>" title="店铺名称:<%=rsmai("name")%>
创建时间:<%=rsmai("addtime")%>
联系人:<%=rsmai("username")%>"><%=left(rsmai("name"),7) %></a></td> <td height="29" width="5" > </td> </tr> </table></div> </td> <% rsmai.movenext loop Rsmai.Close Set Rsmai=Nothing %><%end if%> </tr> </table> </div>